UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7i9svXi66rs5bc8FtGfG4a0olnD68p5FlHPTgW4KitU='
WHERE
key_id = 'adff1bc1921ee3033b56cb62618cf60ab176511d98790441a0e5df0f3ec21cd1'
AND (
token = '7i9svXi66rs5bc8FtGfG4a0olnD68p5FlHPTgW4KitU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)