UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oRsZA5W6r4ew8KHSbUU945sWGR8NnEM33F/8VcGKwwU='
WHERE
key_id = '9c42e7514075e565d6f967172d620ce2cfd397313c7ca73c93157e2266babf27'
AND (
token = 'oRsZA5W6r4ew8KHSbUU945sWGR8NnEM33F/8VcGKwwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)