UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/X9zVIgVllX2HmToU/ZJmpC4QI4Py1hX6liuZB25YsY='
WHERE
key_id = '2c419d9220b15c166a74d13bcda147c55bf515281f762a82e94725e5b03525ed'
AND (
token = '/X9zVIgVllX2HmToU/ZJmpC4QI4Py1hX6liuZB25YsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)