UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zilb31pfCFP3ji89bFICNtYs93/wPB0yvjyVcon5CAs='
WHERE
key_id = 'dc188ca7789e95d39a003182b1d645963d216402ad63a2ee573de4028bc8e46d'
AND (
token = 'zilb31pfCFP3ji89bFICNtYs93/wPB0yvjyVcon5CAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)