UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1rBE8EYASapmjUbI7XKL1vTb1WPiRD6eAaHxw5AIbw='
WHERE
key_id = 'beb070152fd67ed3f63553cf07b90623c2043921466fa661f0e45fe5e9d8de3a'
AND (
token = 'V1rBE8EYASapmjUbI7XKL1vTb1WPiRD6eAaHxw5AIbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)