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