UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mOdrRBtbd89ivXci/V4o8L8V07HAuFzejO9ccg7N2dI='
WHERE
key_id = 'e23ebbf44be66137b23e24213e933e3d4d50689098bfa8d78590a93d889450ae'
AND (
token = 'mOdrRBtbd89ivXci/V4o8L8V07HAuFzejO9ccg7N2dI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)