UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AuRI27R3uCX+My35XEiQWoL9ja49HgEN2HLv9upuolA='
WHERE
key_id = '6fb2a7d93f64a7d51a930b6c420f54f8aaf36d9d1a9e912238bfb69ad073a554'
AND (
token = 'AuRI27R3uCX+My35XEiQWoL9ja49HgEN2HLv9upuolA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)