UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQxiHmU+bnjwMY/gvvW2waXS6vFFb8JIlNiDaEgvnFk='
WHERE
key_id = 'e9b0dde449a5138ba4669913df3a49c0d24633c380f64b586b90a748d6c13366'
AND (
token = 'LQxiHmU+bnjwMY/gvvW2waXS6vFFb8JIlNiDaEgvnFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)