UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kpSGsFzc7iP+3WOYE0u/rdpYdEFVQEFZpohU/E+nlb4='
WHERE
key_id = 'cb0af6c1b9ea8fdebaf27a32837990cdfd238bb330b7f888035ab7840720e4dd'
AND (
token = 'kpSGsFzc7iP+3WOYE0u/rdpYdEFVQEFZpohU/E+nlb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)