UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNgr1GxwRhPoC3BKK6K4EX0DY28lj4lG8ZDAaIxQEX0='
WHERE
key_id = '96e6085696e3cc08a1de8987295cf808b290b7c7c7abd295cfa1ba90c94a6712'
AND (
token = 'CNgr1GxwRhPoC3BKK6K4EX0DY28lj4lG8ZDAaIxQEX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)