UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KP0/Q8Xmnw26SY0pdWuJV95qMd35cS9TFkusvvAFy9k='
WHERE
key_id = 'ac0059b36cf5b064144423fa7e77bcc0a8f19c399ac44c163926ac1d131a63fa'
AND (
token = 'KP0/Q8Xmnw26SY0pdWuJV95qMd35cS9TFkusvvAFy9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)