UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mDXLoM7eM5V7BhcCjCR+FPXwwP90bYBMljEJrnMejzs='
WHERE
key_id = 'cdfffdd4cc318a6fa5da24224f8deec027137e3b8de7f96df5ce40105fa8004d'
AND (
token = 'mDXLoM7eM5V7BhcCjCR+FPXwwP90bYBMljEJrnMejzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)