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