UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VTUwZOVQhi+NPuAA6Kd/ShXAHH+B2cTNf5mvPa1dJws='
WHERE
key_id = '77a4f15853378bd4e1c29e7331de1c85a800b607763d712edd58f24fb05e49dc'
AND (
token = 'VTUwZOVQhi+NPuAA6Kd/ShXAHH+B2cTNf5mvPa1dJws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)