UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Lv4zaXlkL6OstPD8yLKanaF+vinFYon0zxSTmp4icw='
WHERE
key_id = 'c8a6248aa110e92caafcf22270a03747c8dc41dafef3bae2c85868eb80de55bf'
AND (
token = '8Lv4zaXlkL6OstPD8yLKanaF+vinFYon0zxSTmp4icw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)