UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gSb7nn1v8sHTDcq0PLbPiRzj4r6ixSsEb++3q/a/KH4='
WHERE
key_id = '05c04f19bd287b8957b1aac1f829c16ecc8d04fd2d58c666c0d4ca5882767c5a'
AND (
token = 'gSb7nn1v8sHTDcq0PLbPiRzj4r6ixSsEb++3q/a/KH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)