UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bYJqPW3EVY8sA9DU5Ekr3XWJKIf1xCgQTlUe0XcF94I='
WHERE
key_id = '97071b2644a1dce0cf24e5b3cbcce37668ce2e72876b4ec42f2c3e981e02f5aa'
AND (
token = 'bYJqPW3EVY8sA9DU5Ekr3XWJKIf1xCgQTlUe0XcF94I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)