UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Lq4qvoY8YHPfretVaIKmj6y8d/cCM5dbQZCgeBXJek='
WHERE
key_id = 'ba9bf614f78d21863161a0d8868f52b216a12afc92354f873ad592b1d055775d'
AND (
token = '5Lq4qvoY8YHPfretVaIKmj6y8d/cCM5dbQZCgeBXJek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)