UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5Nfsqleil0AZG6OEn28i8V1LM8Jx88YWLP47rX3kz4='
WHERE
key_id = '39209ea807183d92a851a1b3bd991bd13be379e585f359e8be46e34946ae5b31'
AND (
token = 'r5Nfsqleil0AZG6OEn28i8V1LM8Jx88YWLP47rX3kz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)