UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3JfcdH4Sc8sPeCuOabvG8cstkkaJRH4t5LkDtXrmlXg='
WHERE
key_id = '31795ea36c1181f3150fc413c6795f1f3a0b126bda1a6a9bb88f47d2ff63ce9d'
AND (
token = '3JfcdH4Sc8sPeCuOabvG8cstkkaJRH4t5LkDtXrmlXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)