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