UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aN55fM2GUlfDJ07obKW6j8LgDwOOPlGik4pFzYdhXxU='
WHERE
key_id = '047ce1362de28ebb92c2e5f29073caf6535602f17f7250a5ee5727344cc9ef09'
AND (
token = 'aN55fM2GUlfDJ07obKW6j8LgDwOOPlGik4pFzYdhXxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)