UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jPdCkTLlCHEXM/JYwabCeBzfgWTguP7O5oU6M6Vq48I='
WHERE
key_id = '648763a888a9da9fa44dd4269a9ad452af4b2160e5de272477022d969dd94b6d'
AND (
token = 'jPdCkTLlCHEXM/JYwabCeBzfgWTguP7O5oU6M6Vq48I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)