UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ipryBKFPkqel+Dea4uqgFiBI0xFQ837lH3vRL3HDZR8='
WHERE
key_id = 'a86775cc1ca50d0153f13aabf4dda84bdcf3527a289f496b9d8a91058764df8b'
AND (
token = 'ipryBKFPkqel+Dea4uqgFiBI0xFQ837lH3vRL3HDZR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)