UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S0GpNGFj6k+cGrJ8ZqieicuwRmTK49UKp95QbpqeNuw='
WHERE
key_id = '01871d81f9e6658db6d1e3d9d3fc27215abab5cea8bc718f4d3dda939204dae2'
AND (
token = 'S0GpNGFj6k+cGrJ8ZqieicuwRmTK49UKp95QbpqeNuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)