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