UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KUIeM8oT4m3MGkAU76mCy/m+nDkUUOLUcBRTz0rSDnE='
WHERE
key_id = 'e9ed8922e1a62b520f2078245766f9c57dbdc53559b7b8141f5a7f99baca28a0'
AND (
token = 'KUIeM8oT4m3MGkAU76mCy/m+nDkUUOLUcBRTz0rSDnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)