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