UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX0rpleof9kzBEgYrMXGWi2s2nBFKB0n5hjTLBZxLQI='
WHERE
key_id = '4b22e8d1e543cba116a5c09c0f62c6060e6b5a23d5a7123dcd4c3c051fca9cc3'
AND (
token = 'gX0rpleof9kzBEgYrMXGWi2s2nBFKB0n5hjTLBZxLQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)