UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXp3TLwCUCU6cHVMUXWCLgfVR7e7XTMgoMFAp6tTbrM='
WHERE
key_id = '7ccae054287fd7054a51fa4a9c47ee012336e74baa687965fca7d985da1435d2'
AND (
token = 'yXp3TLwCUCU6cHVMUXWCLgfVR7e7XTMgoMFAp6tTbrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)