UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ouw2vnCr0N2931Vw+yDM8z3AfZ9XifRjTcrM8xD8jD8='
WHERE
key_id = '9e65e2d0903c5b8251708fe8dcd231ace79003b833dc8370a0712c863b6571a4'
AND (
token = 'ouw2vnCr0N2931Vw+yDM8z3AfZ9XifRjTcrM8xD8jD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)