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