UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZREV9kvOTCBjK2mSX0NqQ9QjMywLwj3Y6xqVnlM3hr4='
WHERE
key_id = 'b28768927cbafea1f4ae39768cb95c46301f16e09e8c54634df60bad15dbf00d'
AND (
token = 'ZREV9kvOTCBjK2mSX0NqQ9QjMywLwj3Y6xqVnlM3hr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)