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