UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xpHK9M5NpBSeVA/mfrRKglQ7Pdj84C196FnGoiFysQ='
WHERE
key_id = 'e0690b5e4561036db6280c2a71a8b489d1cb3f35212446c5cf32ff3153a47b75'
AND (
token = '0xpHK9M5NpBSeVA/mfrRKglQ7Pdj84C196FnGoiFysQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)