UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z3man18cxuXw6GziSVXRj3Lb7RVdv/IVflKHynpMD6A='
WHERE
key_id = 'd1cae912eb9893c4817b6e57347b287e057d718605002f7a55cf6c4857fd7a50'
AND (
token = 'z3man18cxuXw6GziSVXRj3Lb7RVdv/IVflKHynpMD6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)