UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vzSZ8pDIPJGhlWAFBwx+Roe88v6m8ok+p9y61BrlW+M='
WHERE
key_id = 'c01db34a4f4c5de47b57c8b276507133a172ba5ffab73800549f9f009a0c6ab0'
AND (
token = 'vzSZ8pDIPJGhlWAFBwx+Roe88v6m8ok+p9y61BrlW+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)