UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLNb+pdK6aXSld2KURw48ToPHfiEJU2IvRMr2w4+fwo='
WHERE
key_id = '9a4d57cd98225101318bcaac7e2a93a92ec45e28f5454fd5846502cb11909097'
AND (
token = 'pLNb+pdK6aXSld2KURw48ToPHfiEJU2IvRMr2w4+fwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)