UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihlAsL17E7ur7RKPaFKegsrHSMeB7RTw0nTiBeaD/DE='
WHERE
key_id = '27670c2e6111876cd98a75cf5b1fb1499de002840451d99dc5574e742a32c09f'
AND (
token = 'ihlAsL17E7ur7RKPaFKegsrHSMeB7RTw0nTiBeaD/DE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)