UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPenbPKhfBR7bnvZdJzXnjnrFPE3I04511lrVwi5uIs='
WHERE
key_id = '0b09f2241aedb4c03981296c62c3e799512b13be0747b3f8d5817d0d0f20277a'
AND (
token = 'HPenbPKhfBR7bnvZdJzXnjnrFPE3I04511lrVwi5uIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)