UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gooxQtUI0BSyY9sBFe9M0y/VFOtDo1hzJvZZcu4ErEA='
WHERE
key_id = 'de0a1921ab67bd5b0675dc222ed8c3cbaa5fb5a5e1fc947a413ec8398ea74917'
AND (
token = 'gooxQtUI0BSyY9sBFe9M0y/VFOtDo1hzJvZZcu4ErEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)