UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFlEHJrrufjse2KRoMVLQr1Okr1fmC5Yko5aLvKbt9o='
WHERE
key_id = 'ac2918e97e891ab2dd77ee05f21e0e72557d053f97e50d49258eba08400ae29d'
AND (
token = 'HFlEHJrrufjse2KRoMVLQr1Okr1fmC5Yko5aLvKbt9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)