UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UHhzU4ljQOVgCHV8/z9phFQ2e+KX2zU+lF8ydLSUQvQ='
WHERE
key_id = 'f4d252ca43b36dc43dae41fa7327a04e14adfef48cf8409975312b79c2b7f477'
AND (
token = 'UHhzU4ljQOVgCHV8/z9phFQ2e+KX2zU+lF8ydLSUQvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)