UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/47plA2/hBaYaERLHwKtqDC+UavuHZzqILboZwWrdCM='
WHERE
key_id = '89cff447bfef8766a354ac47096726136ebf3c86ebc9a6c452542818eaedb2cb'
AND (
token = '/47plA2/hBaYaERLHwKtqDC+UavuHZzqILboZwWrdCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)