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