UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f+HchoTTp6MxXE9Fdo3DSS8EYU6Ei2I2Uv9I97uoaSY='
WHERE
key_id = 'd6569cbf15d2caf43e87ef757aaab383bdc6956d91fa3667c663c32a433c0726'
AND (
token = 'f+HchoTTp6MxXE9Fdo3DSS8EYU6Ei2I2Uv9I97uoaSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)