UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T8JdabJv+2iEavV7q81kLRzN5IK2Gyfz40cPoQhrTdU='
WHERE
key_id = '9717e66c5cee636f73e9412cda6d8442c1089d06370f276022c4aeb3eb1466fc'
AND (
token = 'T8JdabJv+2iEavV7q81kLRzN5IK2Gyfz40cPoQhrTdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)