UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4XZjhXiX8UpXV3vxjLhB5VrpRF38jY4Veuy0TCoS/c='
WHERE
key_id = 'f511336e04a09fd31d49e24aab8ea7512865f58c586ce2b31ae737f8f557ee5b'
AND (
token = 'H4XZjhXiX8UpXV3vxjLhB5VrpRF38jY4Veuy0TCoS/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)