UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TgjwgvsyDNZoe5CbNXzlwPGXHZ6k7ybz+Y5m8iHc0Hc='
WHERE
key_id = '9a2bf9dc9887e3cb1b6ed936c268a18e8e47848e97537058100157fa31304980'
AND (
token = 'TgjwgvsyDNZoe5CbNXzlwPGXHZ6k7ybz+Y5m8iHc0Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)