UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eO0Pdk8NtZ84k88Rf5Dx8gaRC92E8vFgaTNOiwJuGcE='
WHERE
key_id = '5f27f68ebe6b48fa3a6f3629f1e579089b49fdc7d10c8b77585e41fc568a4607'
AND (
token = 'eO0Pdk8NtZ84k88Rf5Dx8gaRC92E8vFgaTNOiwJuGcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)