UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXpkWoTW+pKPmyaeiWeJeiE0KD7yS/SswoJmfCMAXoY='
WHERE
key_id = '5998db43d552642ee894a18475fce30f51a476373f33e777b1a6092492bd346f'
AND (
token = 'XXpkWoTW+pKPmyaeiWeJeiE0KD7yS/SswoJmfCMAXoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)