UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9X7BQJTMI1w5aaqQ+GBuqN+gS118Su4KOK9Cw5UW8+4='
WHERE
key_id = 'd4d944555105c73e577e46894383f7d82c222dc801eab2b569ffc901f89c8721'
AND (
token = '9X7BQJTMI1w5aaqQ+GBuqN+gS118Su4KOK9Cw5UW8+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)