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