UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mayNE5209JmiV9YZPqsAdiI1pUGi2JE2kNvbC/xdBA4='
WHERE
key_id = 'b3840f04d7e2d6730b985388f3471536f42f12322848af70d73853f3d3d02b7c'
AND (
token = 'mayNE5209JmiV9YZPqsAdiI1pUGi2JE2kNvbC/xdBA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)